package com.byxy.ssm.demo.dao;

import java.util.List;

import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;

import com.byxy.ssm.demo.entity.Tip;

public interface TipDao {
	@Results({ 
		@Result(column = "tip_id", property = "tipId", id = true),
		@Result(column = "user_id", property = "userId"), 
		@Result(column = "tab_id", property = "tabId"),
		@Result(column = "tip_title", property = "tipTitle"),
		@Result(column = "tip_content", property = "tipContent"),
		@Result(column = "tip_publishTime", property = "tipPublishTime"),
		@Result(column = "tip_modifyTime", property = "tipModifyTime"),			
		@Result(column = "tip_click", property = "tipClick"),
		@Result(column = "tip_isDeleted", property = "tipIsDeleted"),
		@Result(column = "tip_isKnot", property = "tipIsKnot"),
		@Result(column = "tip_replies", property = "tipReplies") 
	})
	@Select("select *  from tip order by tip_modifyTime desc limit 0,5")
	List<Tip> tips();
}
